/*
MySQL Data Transfer
Source Host: localhost
Source Database: denn
Target Host: localhost
Target Database: denn
Date: 4/30/2014 12:00:32 PM
*/

-- ----------------------------
-- Table structure for diasvence
-- ----------------------------
CREATE TABLE `diasvence` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `diasvence` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for objetivoforaneo
-- ----------------------------
CREATE TABLE `objetivoforaneo` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `oficio` varchar(32) DEFAULT NULL,
  `rj` varchar(32) DEFAULT NULL,
  `fechasolict` date DEFAULT NULL,
  `fechainicio` date DEFAULT NULL,
  `fechavenc` date DEFAULT NULL,
  `objetivo` varchar(64) DEFAULT NULL,
  `solicitadopor` varchar(64) DEFAULT NULL,
  `nombrecaso` varchar(128) DEFAULT NULL,
  `fiscal` varchar(128) DEFAULT NULL,
  `tipificacion` varchar(128) DEFAULT NULL,
  `operadora` varchar(32) DEFAULT NULL,
  `nombreuser` varchar(32) DEFAULT NULL,
  `apellidouser` varchar(32) DEFAULT NULL,
  `fechasist` date DEFAULT NULL,
  `maquina` varchar(64) DEFAULT NULL,
  `ip` varchar(16) DEFAULT NULL,
  `diasvence` int(11) DEFAULT NULL,
  `nota` varchar(1024) DEFAULT NULL,
  `direccion` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for operadoratel
-- ----------------------------
CREATE TABLE `operadoratel` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `descripcion` varchar(16) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for tblusuario
-- ----------------------------
CREATE TABLE `tblusuario` (
  `idUsuario` int(11) NOT NULL AUTO_INCREMENT,
  `nombreapellido` varchar(50) DEFAULT NULL,
  `strNombre` varchar(50) DEFAULT NULL,
  `strapellido` varchar(30) DEFAULT NULL,
  `strusuario` varchar(30) DEFAULT NULL,
  `cedula` varchar(15) DEFAULT NULL,
  `celular` varchar(15) DEFAULT NULL,
  `telefono` varchar(15) DEFAULT NULL,
  `streEmail` varchar(100) DEFAULT NULL,
  `rango` varchar(30) DEFAULT NULL,
  `depart` varchar(64) DEFAULT NULL,
  `subdirecadjunta` varchar(100) DEFAULT NULL,
  `intActivo` int(11) DEFAULT NULL,
  `strpassword` varchar(50) DEFAULT NULL,
  `intnivel` int(11) DEFAULT NULL,
  `fechasist` date DEFAULT NULL,
  PRIMARY KEY (`idUsuario`)
) ENGINE=MyISAM AUTO_INCREMENT=85 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records 
-- ----------------------------
INSERT INTO `diasvence` VALUES ('1', '5');
INSERT INTO `objetivoforaneo` VALUES ('1', 'WQERW', 'EWRE', '2014-04-10', '2014-04-10', '2014-05-10', '(829) 497-4972', 'DSA FA', 'SADFSDF', 'ASDFSDA', 'ASDFDF', 'CLARO', null, null, null, null, null, '5', null, 'DINTEL');
INSERT INTO `objetivoforaneo` VALUES ('2', 'AS D', 'SDFSDF', '2014-04-10', '2014-04-10', '2014-05-10', '(809) 497-4972', 'SAAGD', null, null, null, 'CLARO', null, null, null, null, null, '5', null, 'DINTEL');
INSERT INTO `objetivoforaneo` VALUES ('3', 'SFSA', 'SAASD F', '2014-04-10', '2014-04-10', '2014-05-10', '(849) 325-3413', 'SFSDFADSF', 'SDFDSF', 'FDSDF', 'AFSFD', 'CLARO', null, null, null, null, null, '5', null, 'DINTEL');
INSERT INTO `objetivoforaneo` VALUES ('4', 'FDADS', 'SDFDSF', '2014-04-05', '2014-04-05', '2014-05-05', '(809) 232-3242', 'SADF AS', 'SDFSDF', 'SFSDF', 'SDAFAF', 'CLARO', null, null, null, null, null, '5', null, 'DINTEL');
INSERT INTO `objetivoforaneo` VALUES ('5', 'DS VSDF ', 'SAAGOE R', '2014-04-05', '2014-04-05', '2014-05-05', '(809) 234-6435', 'BVF NDF H', 'FDSGSDG', 'JTGHFGH', 'GHFET', 'VIVA', null, null, null, null, null, '5', null, 'DICRIM');
INSERT INTO `objetivoforaneo` VALUES ('6', 'ASH FHDFG', 'FGHDFG', '2014-04-05', '2014-04-05', '2014-05-05', '(829) 547-6745', 'SAAWER', 'GFHGDH', 'GFHGFH', 'GFHGFD  GHDFH', 'VIVA', null, null, null, null, null, '5', null, 'DICRIM');
INSERT INTO `objetivoforaneo` VALUES ('7', 'FFDGGF', 'DFFDGFD', '2014-04-03', '2014-04-03', '2014-05-03', '(829) 436-4564', 'SDADSFA', 'SDFSD', 'SDAFSD', 'DSFA', 'ORANGE', null, null, null, null, null, '5', null, 'DICRIM');
INSERT INTO `objetivoforaneo` VALUES ('8', 'SD', 'SAAWPOR U', '2014-04-02', '2014-04-02', '2014-05-02', '(829) 497-4975', 'SDF', 'SD', 'SADF', 'SAF', 'ORANGE', null, null, null, null, null, '0', null, 'DICAI');
INSERT INTO `objetivoforaneo` VALUES ('9', 'asSDFLJ', 'HRTRAS', '2014-04-03', '2014-04-03', '2014-05-03', '(809) 324-2342', 'SDRDG', 'FDGGF', 'SDFDS', 'SDF', 'CLARO', null, null, null, null, null, '5', null, 'DICAI');
INSERT INTO `objetivoforaneo` VALUES ('10', 'HGJGFJ', 'GH FGHas', '2014-04-05', '2014-04-05', '2014-05-05', '(809) 213-4234', 'SDFSDF', 'SDFSDFSD', 'SDFSDF', 'AFDS', 'ORANGE', null, null, null, null, null, '5', null, 'DICAN');
INSERT INTO `objetivoforaneo` VALUES ('11', 'DSADF', 'SDAFSDF', '2014-04-27', '2014-04-27', '2014-05-05', '(849) 342-4234', 'DSFASDF', 'SFASD', 'DSFAD', 'AFSSD', 'TRICOM', 'angelbrito31', 'angelbrito31', '2014-04-27', null, null, '5', null, 'DICAN');
INSERT INTO `objetivoforaneo` VALUES ('12', 'sadf', 'SAASA J;', '2014-04-29', '2014-04-29', '2014-04-29', '(809) 664-6446', 'SAASDLA', 'ld jsa', 'd;lsfj ', ';adlfj', 'CLARO', null, null, '2014-04-29', null, null, '5', 'sadfsd', 'DICAN');
INSERT INTO `operadoratel` VALUES ('1', 'CLARO');
INSERT INTO `operadoratel` VALUES ('2', 'ORANGE');
INSERT INTO `operadoratel` VALUES ('3', 'VIVA');
INSERT INTO `operadoratel` VALUES ('4', 'TRICOM');
INSERT INTO `tblusuario` VALUES ('23', 'Angel Dario Brito Paulino', 'Angel Dario', 'Brito Paulino', 'angelbrito19', '001-0842188-4', '809-481-8508', '809-388-0113', 'angelbrito19@yahoo.com', 'Primer Teniente', null, 'Direccion Adjunta Santo Domingo Este', '1', 'abm', '1', null);
INSERT INTO `tblusuario` VALUES ('31', 'Ramon F. Santana', 'Ramon F.', 'Santana', 'ramon.santana', null, null, null, 'lenin.santana@hotmail.com', null, null, null, '1', 'Dintel27', '1', null);
INSERT INTO `tblusuario` VALUES ('32', 'Nathalie Encarnacion Almonte \r\n', 'Nathalie ', 'Encarnacion Almonte', 'nathalie.encarnacion', null, null, null, 'luistrinidadwild@gmail.com', null, null, null, '1', 'Dintel27', '1', null);
INSERT INTO `tblusuario` VALUES ('33', 'Anny Sugely Paula Contreras \r\n', 'Anny Sugely', 'Paula Contreras', 'anny.sugely', null, null, null, 'gotier@gmail.com', null, null, null, null, 'Dintel27', '1', null);
INSERT INTO `tblusuario` VALUES ('34', 'Samuel Baez Carrion', 'Samuel', 'Baez Carrion', 'samuel.baez', null, null, null, 'gotier@gmail.com', null, null, null, null, 'Dintel27', '1', null);
INSERT INTO `tblusuario` VALUES ('35', 'Kiara Guerrero Santana', 'Kiara', 'Guerrero Santana', 'kiara.guerrero', null, null, null, 'margia@hotmail.c', null, null, null, null, 'Dintel27', '1', null);
INSERT INTO `tblusuario` VALUES ('36', 'Elvin Ogando Montero', 'Elvin', 'Ogando Montero', 'elvin.ogando', '001-8976541-1', '809-232-1223', '809-388-0113', 'anyelelmorenito@hotmail.com', 'Cabo', null, 'Direccion Adjunta la Vega', null, 'Dintel27', '1', null);
INSERT INTO `tblusuario` VALUES ('37', 'Carlos Santana Vasquez', 'Carlos', 'Santana Vasquez', 'carlos.santana', null, null, null, null, null, null, null, null, 'Dintel27', '1', null);
INSERT INTO `tblusuario` VALUES ('38', 'Alvaro Esteban Liriano Ureña', 'Alvaro Esteban', 'Liriano Ureña', 'alvaro.liriano', null, null, null, null, null, null, null, null, 'Dintel27', '1', null);
INSERT INTO `tblusuario` VALUES ('39', 'Jesus Alberto Minier Evangelista', 'Jesus Alberto ', 'Minier Evangelista', 'jesus.minier', null, null, null, null, null, null, null, null, 'Dintel27', '1', null);
INSERT INTO `tblusuario` VALUES ('40', 'Francisco Alburqueque', 'Francisco ', 'Alburqueque', 'francisco.alburqueque', null, null, null, null, null, null, null, null, 'Dintel27', '1', null);
INSERT INTO `tblusuario` VALUES ('41', 'Franklin Del Carmen Martinez', 'Franklin', 'Del Carmen Martinez', 'franklin.delcarmen', null, null, null, null, null, null, null, null, 'Dintel27', '1', null);
INSERT INTO `tblusuario` VALUES ('42', 'Jose Andres Morillo Martinez', 'Jose Andres', 'Morillo Martinez', 'jose.morillo', null, null, null, null, null, null, null, null, 'Dintel27', '1', null);
INSERT INTO `tblusuario` VALUES ('43', 'Diana Arnaud De la Cruz', 'Diana', 'Arnaud De la Cruz', 'diana.arnaud', null, null, null, null, null, null, null, null, 'Dintel27', '1', null);
INSERT INTO `tblusuario` VALUES ('44', 'Carolina Scarlet Vasquez Suarez', 'Carolina Scarlet', 'Vasquez Suare', 'carolina.vasquez', null, null, null, null, null, null, null, null, 'caroll100207205', '1', null);
INSERT INTO `tblusuario` VALUES ('45', 'Radhames Lantigua Santiago', 'Radhames', 'Lantigua Santiago', 'radhames.lantigua', null, null, null, null, null, null, null, null, 'Dintel27', '1', null);
INSERT INTO `tblusuario` VALUES ('46', 'Breilyn Fernandez Reyes', 'Breilyn', 'Fernandez Reyes', 'breilyn.fernandez', null, null, null, null, null, null, null, null, '301993', '1', null);
INSERT INTO `tblusuario` VALUES ('47', 'Sairis Vidal Doñe', 'Sairis', 'Vidal Doñe', 'sairis.vidal', null, null, null, null, null, null, null, null, 'DVSREGA', '1', null);
INSERT INTO `tblusuario` VALUES ('48', 'Francisco Enmanuel Rodriguez Mariñez', 'Francisco', 'Enmanuel Rodriguez Mariñez', 'francisco.rodriguez', '084-0017543-9', null, null, null, null, null, null, null, 'Dintel27', '1', null);
INSERT INTO `tblusuario` VALUES ('49', 'Doily Jose Luis Rodriguez Gomez', 'Doily Jose Luis', 'Rodriguez Gomez', 'doily.rodriguez', null, null, null, null, null, null, null, null, 'primary1', '1', null);
INSERT INTO `tblusuario` VALUES ('50', 'Danessa Quezada Mieses', 'Danessa', 'Quezada Mieses', 'danessa.quezada', null, null, null, null, null, null, null, null, 'Dintel27', '1', null);
INSERT INTO `tblusuario` VALUES ('51', 'Eddison Alexander Duverge C.', 'Eddison Alexander', 'Duverge C.', 'eddison.duverge', null, null, null, null, null, null, null, null, 'EDDI100094209', '1', null);
INSERT INTO `tblusuario` VALUES ('52', 'Ramayri Moreta Encarnacion', 'Ramayri', 'Moreta Encarnacion', 'ramayri.moreta', null, null, null, null, null, null, null, null, 'Dintel27', '1', null);
INSERT INTO `tblusuario` VALUES ('53', 'Eduardo Brito', 'Eduardo', 'Brito', 'eduardo.brito', '001-0382244-1', null, null, null, null, null, null, null, 'Dintel27', '1', null);
INSERT INTO `tblusuario` VALUES ('54', 'Pedro Julio Fermin Tavarez', 'Pedro Julio', 'Fermin Tavarez', 'pedro.fermin', '223-0086329-1', null, null, null, null, null, null, null, 'chanel2316', '1', null);
INSERT INTO `tblusuario` VALUES ('55', 'Mariela Zabala', 'Mariela', 'Zabala', 'mariela.zabala', '011-0038876-6', null, null, null, null, null, null, null, '1602', '1', null);
INSERT INTO `tblusuario` VALUES ('56', 'Denny Diaz', 'Denny', 'Diaz', 'coronel.denny.diaz', null, null, null, null, null, null, null, null, 'dintel27', '1', null);
INSERT INTO `tblusuario` VALUES ('57', 'Arturo Pujols', 'Arturo', 'Pujols', 'general.arturo.pujols', null, null, null, null, null, null, null, null, 'dintel27', '1', null);
INSERT INTO `tblusuario` VALUES ('58', 'Cinthia Susaña Veloz', 'Cinthia', 'Susaña', 'cinthia.veloz', null, null, null, null, null, null, null, null, 'dintel27', '1', null);
INSERT INTO `tblusuario` VALUES ('59', 'Nadia Castro', 'Nadia', 'Castro', 'nadia.castro', null, null, null, null, null, null, null, null, 'dintel27', '1', null);
INSERT INTO `tblusuario` VALUES ('60', 'Ramon Antonio Ruiz Estrella', 'Ramon Antonio', 'Ruiz Estrella', 'capitan.ramon.ruiz', null, null, null, null, 'Capitan', 'Investigacion y Seguimiento Reclamos Sociales', null, '2', 'dintel27', '2', null);
INSERT INTO `tblusuario` VALUES ('61', 'Miguel Angel de los Santos', 'Miguel Angel', 'De Los Santos', 'miguel.delossantos', null, null, null, null, 'Sargento Mayor', 'Procesamiento de Datos', null, '3', 'dintel27', '3', null);
INSERT INTO `tblusuario` VALUES ('62', 'Favio Augusto Vicioso de Los Santos', 'Fabio Augusto', 'Vicioso De Los Santos', 'fabio.vicioso', null, null, null, null, '1er. Teniente', 'Direccion de Recoleccion de Informes', null, null, 'dintel27', '1', null);
INSERT INTO `tblusuario` VALUES ('63', 'Feliz Alberto Gomez Almonte', 'Feliz Alberto', 'Gomez Almonte', 'feliz.gomez', null, null, null, null, 'Capitan', 'Unidad Manjeo de Fuentes y Colaboradores', null, null, 'dintel27', '1', null);
INSERT INTO `tblusuario` VALUES ('64', 'Reynilio Castillo Aquino', 'Reynilio', 'Castillo Aquino', 'reynilio.castillo', null, null, null, null, 'Mayor', 'Centro de Informacion', null, null, 'dintel27', '1', null);
INSERT INTO `tblusuario` VALUES ('65', 'Angel Brito', 'Angel ', 'Brito', 'angelbrito1119', null, null, null, null, null, null, null, null, 'abm', '3', null);
INSERT INTO `tblusuario` VALUES ('66', 'Angel Brito', 'Angel ', 'Brito', 'angelbrito119', null, null, null, null, null, null, null, null, 'abm', '2', null);
INSERT INTO `tblusuario` VALUES ('67', 'Carlos Ramon Hilario de la Rosa', 'Carlos Ramon', 'Hilario de la Rosa', 'carlos.hilario', '049-0075906-1', null, null, null, null, 'Centro Integral', null, null, '7777777', '1', null);
INSERT INTO `tblusuario` VALUES ('68', 'melissa.proceso', 'Melissa', null, 'melissa.proceso', null, null, null, null, null, null, null, null, 'dintel27', '3', null);
INSERT INTO `tblusuario` VALUES ('69', 'gregorio.proceso', 'Gregorio', null, 'gregorio.proceso', null, null, null, null, null, null, null, null, 'dintel27', '3', null);
INSERT INTO `tblusuario` VALUES ('70', 'Coronel Elvira Ulloa Rodriguez', 'Elvira', 'Ulloa Rodriguez', 'coronel.elvira.ulloa', '', '829-222-2886', '809-756-0294', 'elviraulloar@hotmail.com', 'Coronel', 'Centro Integral', null, null, 'dintel27', '1', null);
INSERT INTO `tblusuario` VALUES ('71', 'Jose Perez', null, null, 'jose.perez', null, null, null, null, null, null, null, null, 'dintel.27', '1', null);
INSERT INTO `tblusuario` VALUES ('72', null, null, null, 'angelbrito119', null, null, null, null, null, null, null, null, 'abm', '2', null);
INSERT INTO `tblusuario` VALUES ('73', null, null, null, 'angelbrito1119', null, null, null, null, null, null, null, null, 'abm', '3', null);
INSERT INTO `tblusuario` VALUES ('74', 'Edison Cabrera', 'Edison', 'Cabrera', 'edison.cabrera', null, null, null, null, null, null, null, null, 'republicadominicana', '4', null);
INSERT INTO `tblusuario` VALUES ('75', 'Elvira Ulloa', 'Elvira', 'Ulloa', 'elvira.ulloa', null, null, null, null, null, null, null, null, 'elviraulloa', null, null);
INSERT INTO `tblusuario` VALUES ('76', 'Isneria Jaqueline Ulloa Cruz', 'Isneria Jaqueline', 'Ulloa Cruz', 'isneria.ulloa', null, null, null, null, null, null, null, null, 'isn11', '1', null);
INSERT INTO `tblusuario` VALUES ('77', 'Franklin Del Carmen Martinez', 'Franklin ', 'Del Carmen Martinez', 'franklin.martinez', null, null, null, null, null, null, null, null, 'franklin0401', '1', null);
INSERT INTO `tblusuario` VALUES ('78', 'angelbrito31', 'angelbrito31', 'angelbrito31', 'angelbrito31', null, null, null, null, null, null, null, null, 'abm', '31', null);
INSERT INTO `tblusuario` VALUES ('79', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `tblusuario` VALUES ('80', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `tblusuario` VALUES ('81', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `tblusuario` VALUES ('82', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `tblusuario` VALUES ('83', null, 'yyyyyyyyyyyyy', 'yyyyyyyyyyyyy', 'yyyyyyyyyy', '222-2222222-2', '(333) 333-3333', '(444) 444-4444', '555555555', null, null, null, null, '555555555', '31', null);
INSERT INTO `tblusuario` VALUES ('84', null, 'AAA', 'AAAA', 'AAAAAA', '333-3333333-3', '(444) 444-4444', '(555) 555-5555', 'EEEEEE', null, null, null, null, 'EEEEEE', '31', null);
